-
Re: How to put a date and time together in a column?
Hey @Simran Curry Smartsheet currently doesn't allow timestamps except in the system Modified and Created columns. The only way to display the timestamp, as you have found, is as a text column. One m…2 · -
Re: Index collect formula question
Hey @Enoch Maki Evaluating multiselect cells require the specific functions of HAS, CONTAIN or FIND. With a multiselect- Contact field use the HAS function. =IFERROR(INDEX(COLLECT([Location and Event…1 · -
Re: Index collect formula question
Hey @Enoch Mak For your Location and Event collect - as a quick test (be sure to turn OFF Column Formulas if it is turned on before doing this) in one cell, remove range&criteria from the formula…1 · -
Re: Formula calculating Status on Parent and Child Rows
Hey @Laurenzella Will this work for you? =IF([Project Status Override]# <> "", [Project Status Override]#, IF(AND(COUNTIFS([Tasks Not Needed]:[Tasks Not Needed], 0, Summary:Summary, 0…1 · -
Re: Average of values if criteria is met in two other columns
Hey @shoey24 Change your AVERAGEIF to AVG. The COLLECT function is filtering the same as the IVERAGEIF function would =AVG(COLLECT({Days Open}, {Date Closed}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY(…1 ·